Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	92872
Missing cells	27053
Missing cells (%)	2.2%
Duplicate rows	27
Duplicate rows (%)	< 0.1%
Total size in memory	9.2 MiB
Average record size in memory	104.0 B

Variable types

Categorical	1
Numeric	12

Warnings

Dataset has 27 (< 0.1%) duplicate rows	Duplicates
`Liquidity` is highly correlated with `Return on Equity`	High correlation
`Return on Equity` is highly correlated with `Liquidity`	High correlation
`EPS` is highly correlated with `Profitability` and 3 other fields	High correlation
`Profitability` is highly correlated with `EPS` and 3 other fields	High correlation
`Productivity` is highly correlated with `EPS` and 3 other fields	High correlation
`Operational Margin` is highly correlated with `EPS` and 3 other fields	High correlation
`Return on Equity` is highly correlated with `EPS` and 3 other fields	High correlation
`Assets Growth` is highly correlated with `Employee Growth`	High correlation
`Employee Growth` is highly correlated with `Assets Growth`	High correlation
`EPS` is highly correlated with `Productivity` and 1 other fields	High correlation
`Profitability` is highly correlated with `Productivity`	High correlation
`Productivity` is highly correlated with `EPS` and 3 other fields	High correlation
`Operational Margin` is highly correlated with `Productivity`	High correlation
`Return on Equity` is highly correlated with `EPS` and 1 other fields	High correlation
`Return on Equity` is highly correlated with `EPS`	High correlation
`Liquidity` is highly correlated with `Profitability`	High correlation
`Profitability` is highly correlated with `Liquidity`	High correlation
`EPS` is highly correlated with `Return on Equity`	High correlation
`Operational Margin` has 5557 (6.0%) missing values	Missing
`Assets Growth` has 6701 (7.2%) missing values	Missing
`Sales Growth` has 6701 (7.2%) missing values	Missing
`Employee Growth` has 7010 (7.5%) missing values	Missing
`EPS` is highly skewed (γ1 = -137.6928255)	Skewed
`Liquidity` is highly skewed (γ1 = -138.2539813)	Skewed
`Profitability` is highly skewed (γ1 = -50.43091391)	Skewed
`Productivity` is highly skewed (γ1 = -80.9125844)	Skewed
`Leverage Ratio` is highly skewed (γ1 = 290.9228157)	Skewed
`Asset Turnover` is highly skewed (γ1 = 70.7239712)	Skewed
`Operational Margin` is highly skewed (γ1 = -81.07270041)	Skewed
`Return on Equity` is highly skewed (γ1 = -165.8537632)	Skewed
`Assets Growth` is highly skewed (γ1 = 137.2063306)	Skewed
`Sales Growth` is highly skewed (γ1 = 191.0078837)	Skewed
`Employee Growth` is highly skewed (γ1 = 128.4063963)	Skewed
`EPS` has 1833 (2.0%) zeros	Zeros
`Liquidity` has 1706 (1.8%) zeros	Zeros
`Productivity` has 1581 (1.7%) zeros	Zeros
`Leverage Ratio` has 17809 (19.2%) zeros	Zeros
`Asset Turnover` has 5907 (6.4%) zeros	Zeros
`Operational Margin` has 1360 (1.5%) zeros	Zeros
`Return on Equity` has 2355 (2.5%) zeros	Zeros
`Sales Growth` has 5018 (5.4%) zeros	Zeros
`Employee Growth` has 7394 (8.0%) zeros	Zeros

Reproduction

Analysis started	2021-09-12 15:31:45.011693
Analysis finished	2021-09-12 15:32:44.510135
Duration	59.5 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

BK
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.1 MiB

0	92314
1	558

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	92872
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	92314	99.4%
1	558	0.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	92314	99.4%
1	558	0.6%

Most occurring characters

Value	Count	Frequency (%)
0	92314	99.4%
1	558	0.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	92872	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	92314	99.4%
1	558	0.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	92872	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	92314	99.4%
1	558	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	92872	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	92314	99.4%
1	558	0.6%

EPS
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	5161
Distinct (%)	5.6%
Missing	5
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-14.46135521

Minimum	-384000
Maximum	55339
Zeros	1833
Zeros (%)	2.0%
Negative	33992
Negative (%)	36.6%
Memory size	725.7 KiB

Quantile statistics

Minimum	-384000
5-th percentile	-1.85
Q1	-0.14
median	0.33
Q3	1.53
95-th percentile	4.3
Maximum	55339
Range	439339
Interquartile range (IQR)	1.67

Descriptive statistics

Standard deviation	2195.467288
Coefficient of variation (CV)	-151.8161511
Kurtosis	20817.46
Mean	-14.46135521
Median Absolute Deviation (MAD)	0.749
Skewness	-137.6928255
Sum	-1342982.674
Variance	4820076.611
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1833	2.0%
-0.01	1593	1.7%
-0.02	1269	1.4%
-0.03	1014	1.1%
-0.04	906	1.0%
-0.05	839	0.9%
-0.06	722	0.8%
-0.07	654	0.7%
0.01	652	0.7%
-0.09	565	0.6%
Other values (5151)	82820	89.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-384000	1	< 0.1%
-321898	1	< 0.1%
-314893	1	< 0.1%
-205000	1	< 0.1%
-152322	1	< 0.1%
-129042.5	1	< 0.1%
-48200	1	< 0.1%
-42419	1	< 0.1%
-41804	1	< 0.1%
-11213	1	< 0.1%

Value	Count	Frequency (%)
55339	1	< 0.1%
51277	1	< 0.1%
42176	1	< 0.1%
28520	1	< 0.1%
28000	1	< 0.1%
14725	1	< 0.1%
13416	1	< 0.1%
5209	1	< 0.1%
1543	1	< 0.1%
1066.14	1	< 0.1%

Liquidity
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	3114
Distinct (%)	3.4%
Missing	247
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	-2.631237398

Minimum	-25968.52
Maximum	1
Zeros	1706
Zeros (%)	1.8%
Negative	18343
Negative (%)	19.8%
Memory size	725.7 KiB

Quantile statistics

Minimum	-25968.52
5-th percentile	-0.48
Q1	0.02
median	0.19
Q3	0.4
95-th percentile	0.73
Maximum	1
Range	25969.52
Interquartile range (IQR)	0.38

Descriptive statistics

Standard deviation	121.6109207
Coefficient of variation (CV)	-46.21814846
Kurtosis	25278.28839
Mean	-2.631237398
Median Absolute Deviation (MAD)	0.18
Skewness	-138.2539813
Sum	-243718.364
Variance	14789.21603
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1706	1.8%
0.02	1639	1.8%
0.01	1598	1.7%
0.03	1492	1.6%
0.04	1489	1.6%
-0.01	1486	1.6%
0.06	1469	1.6%
0.07	1460	1.6%
0.05	1450	1.6%
0.08	1446	1.6%
Other values (3104)	77390	83.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-25968.52	1	< 0.1%
-13718	1	< 0.1%
-9242	1	< 0.1%
-8658.67	1	< 0.1%
-8556	1	< 0.1%
-6323	1	< 0.1%
-5807.75	1	< 0.1%
-4307	1	< 0.1%
-3169	1	< 0.1%
-3029	1	< 0.1%

Value	Count	Frequency (%)
1	30	< 0.1%
0.992	1	< 0.1%
0.99	43	< 0.1%
0.982	1	< 0.1%
0.98	50	0.1%
0.976	2	< 0.1%
0.97	53	0.1%
0.967	1	< 0.1%
0.96	63	0.1%
0.956	1	< 0.1%

Profitability
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	7040
Distinct (%)	7.6%
Missing	247
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	-29.53727365

Minimum	-79682
Maximum	140.58
Zeros	823
Zeros (%)	0.9%
Negative	39657
Negative (%)	42.7%
Memory size	725.7 KiB

Quantile statistics

Minimum	-79682
5-th percentile	-13.63
Q1	-0.64
median	0.07
Q3	0.31
95-th percentile	0.64
Maximum	140.58
Range	79822.58
Interquartile range (IQR)	0.95

Descriptive statistics

Standard deviation	677.2306671
Coefficient of variation (CV)	-22.92800192
Kurtosis	3709.939983
Mean	-29.53727365
Median Absolute Deviation (MAD)	0.32
Skewness	-50.43091391
Sum	-2735889.972
Variance	458641.3765
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.14	1020	1.1%
0.11	1010	1.1%
0.1	999	1.1%
0.13	979	1.1%
0.16	972	1.0%
0.09	969	1.0%
0.12	955	1.0%
0.17	955	1.0%
0.19	950	1.0%
0.15	947	1.0%
Other values (7030)	82869	89.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-79682	1	< 0.1%
-56186	1	< 0.1%
-49472	1	< 0.1%
-34944.33	1	< 0.1%
-33915	1	< 0.1%
-32719	1	< 0.1%
-30576	1	< 0.1%
-30325.5	1	< 0.1%
-30015.75	1	< 0.1%
-29317	1	< 0.1%

Value	Count	Frequency (%)
140.58	1	< 0.1%
5.74	1	< 0.1%
3.71	1	< 0.1%
2.66	1	< 0.1%
2.36	1	< 0.1%
2.25	1	< 0.1%
2.24	1	< 0.1%
1.98	2	< 0.1%
1.95	1	< 0.1%
1.942	1	< 0.1%

Productivity
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	2823
Distinct (%)	3.0%
Missing	247
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	-1.22287051

Minimum	-5093
Maximum	1102
Zeros	1581
Zeros (%)	1.7%
Negative	29653
Negative (%)	31.9%
Memory size	725.7 KiB

Quantile statistics

Minimum	-5093
5-th percentile	-1.18
Q1	-0.06
median	0.06
Q3	0.11
95-th percentile	0.23
Maximum	1102
Range	6195
Interquartile range (IQR)	0.17

Descriptive statistics

Standard deviation	35.88555642
Coefficient of variation (CV)	-29.34534451
Kurtosis	8888.355102
Mean	-1.22287051
Median Absolute Deviation (MAD)	0.07
Skewness	-80.9125844
Sum	-113268.381
Variance	1287.773159
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.07	4328	4.7%
0.08	4240	4.6%
0.06	4178	4.5%
0.09	4087	4.4%
0.1	3762	4.1%
0.05	3710	4.0%
0.11	3381	3.6%
0.04	3143	3.4%
0.12	2938	3.2%
0.03	2560	2.8%
Other values (2813)	56298	60.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-5093	1	< 0.1%
-4595	1	< 0.1%
-2640	1	< 0.1%
-2598	1	< 0.1%
-2442.17	1	< 0.1%
-2348	1	< 0.1%
-2136	1	< 0.1%
-2103	1	< 0.1%
-1681.5	1	< 0.1%
-1624.75	1	< 0.1%

Value	Count	Frequency (%)
1102	1	< 0.1%
35.92	1	< 0.1%
17.71	1	< 0.1%
17.11	1	< 0.1%
10.7	1	< 0.1%
10.52	1	< 0.1%
7.72	1	< 0.1%
6.48	1	< 0.1%
5.28	1	< 0.1%
5.27	1	< 0.1%

Leverage Ratio
Real number (ℝ)

SKEWED
ZEROS

Distinct	5297
Distinct (%)	5.7%
Missing	26
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.345316276

Minimum	-7811
Maximum	75970.38
Zeros	17809
Zeros (%)	19.2%
Negative	7256
Negative (%)	7.8%
Memory size	725.7 KiB

Quantile statistics

Minimum	-7811
5-th percentile	-0.75
Q1	0
median	0.28
Q3	0.82
95-th percentile	2.75
Maximum	75970.38
Range	83781.38
Interquartile range (IQR)	0.82

Descriptive statistics

Standard deviation	253.0380927
Coefficient of variation (CV)	188.088182
Kurtosis	87527.86679
Mean	1.345316276
Median Absolute Deviation (MAD)	0.28
Skewness	290.9228157
Sum	124907.235
Variance	64028.27634
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	17809	19.2%
0.01	1954	2.1%
0.02	1288	1.4%
0.03	1092	1.2%
0.04	916	1.0%
0.05	851	0.9%
0.06	776	0.8%
0.08	758	0.8%
0.07	748	0.8%
0.1	725	0.8%
Other values (5287)	65929	71.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-7811	1	< 0.1%
-7270.33	1	< 0.1%
-3231.4	1	< 0.1%
-1473.1	1	< 0.1%
-1470.97	1	< 0.1%
-1042.105	1	< 0.1%
-776.59	1	< 0.1%
-676.76	1	< 0.1%
-633.84	1	< 0.1%
-558.52	1	< 0.1%

Value	Count	Frequency (%)
75970.38	1	< 0.1%
3096.64	1	< 0.1%
2238.567	1	< 0.1%
2183.59	1	< 0.1%
2167	1	< 0.1%
1726.9	1	< 0.1%
960.5	1	< 0.1%
936.3	1	< 0.1%
912.54	1	< 0.1%
863.13	1	< 0.1%

Asset Turnover
Real number (ℝ)

SKEWED
ZEROS

Distinct	2987
Distinct (%)	3.2%
Missing	247
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	1.053613323

Minimum	-31.59
Maximum	276.38
Zeros	5907
Zeros (%)	6.4%
Negative	15
Negative (%)	< 0.1%
Memory size	725.7 KiB

Quantile statistics

Minimum	-31.59
5-th percentile	0
Q1	0.39
median	0.83
Q3	1.39
95-th percentile	2.67
Maximum	276.38
Range	307.97
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.115945321
Coefficient of variation (CV)	2.008275024
Kurtosis	7656.622443
Mean	1.053613323
Median Absolute Deviation (MAD)	0.49
Skewness	70.7239712
Sum	97590.934
Variance	4.4772246
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5907	6.4%
0.01	632	0.7%
0.54	570	0.6%
0.63	555	0.6%
0.49	552	0.6%
0.38	546	0.6%
0.46	545	0.6%
0.42	543	0.6%
0.67	540	0.6%
0.5	538	0.6%
Other values (2977)	81697	88.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-31.59	1	< 0.1%
-1.44	1	< 0.1%
-0.49	1	< 0.1%
-0.28	1	< 0.1%
-0.15	2	< 0.1%
-0.11	1	< 0.1%
-0.07	2	< 0.1%
-0.06	1	< 0.1%
-0.03	2	< 0.1%
-0.01	3	< 0.1%

Value	Count	Frequency (%)
276.38	1	< 0.1%
243.67	1	< 0.1%
240.74	1	< 0.1%
182.21	1	< 0.1%
134.63	1	< 0.1%
102.08	1	< 0.1%
83	1	< 0.1%
81.5	1	< 0.1%
71.88	1	< 0.1%
63.5	1	< 0.1%

Operational Margin
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	4511
Distinct (%)	5.2%
Missing	5557
Missing (%)	6.0%
Infinite	0
Infinite (%)	0.0%
Mean	-7.915485174

Minimum	-30175.7
Maximum	394.47
Zeros	1360
Zeros (%)	1.5%
Negative	24522
Negative (%)	26.4%
Memory size	725.7 KiB

Quantile statistics

Minimum	-30175.7
5-th percentile	-4.25
Q1	-0.03
median	0.06
Q3	0.14
95-th percentile	0.31
Maximum	394.47
Range	30570.17
Interquartile range (IQR)	0.17

Descriptive statistics

Standard deviation	214.4600791
Coefficient of variation (CV)	-27.0937377
Kurtosis	9073.757914
Mean	-7.915485174
Median Absolute Deviation (MAD)	0.08
Skewness	-81.07270041
Sum	-691140.588
Variance	45993.12553
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.07	3582	3.9%
0.05	3341	3.6%
0.06	3330	3.6%
0.08	3292	3.5%
0.04	3267	3.5%
0.09	3167	3.4%
0.03	2984	3.2%
0.1	2975	3.2%
0.11	2723	2.9%
0.12	2494	2.7%
Other values (4501)	56160	60.5%
(Missing)	5557	6.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-30175.7	1	< 0.1%
-28236	1	< 0.1%
-15265.3	1	< 0.1%
-13048	1	< 0.1%
-11741.5	1	< 0.1%
-11505	1	< 0.1%
-11278	1	< 0.1%
-10856.67	1	< 0.1%
-10463	1	< 0.1%
-10234	1	< 0.1%

Value	Count	Frequency (%)
394.47	1	< 0.1%
193.14	1	< 0.1%
119.36	1	< 0.1%
85.94	1	< 0.1%
10.82	1	< 0.1%
10.81	1	< 0.1%
10.01	1	< 0.1%
9.29	1	< 0.1%
9.02	1	< 0.1%
2.889	1	< 0.1%

Return on Equity
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	2997
Distinct (%)	3.2%
Missing	8
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-2.11238201

Minimum	-88875.14
Maximum	39500
Zeros	2355
Zeros (%)	2.5%
Negative	34186
Negative (%)	36.8%
Memory size	725.7 KiB

Quantile statistics

Minimum	-88875.14
5-th percentile	-0.95
Q1	-0.08
median	0.03
Q3	0.07
95-th percentile	0.15
Maximum	39500
Range	128375.14
Interquartile range (IQR)	0.15

Descriptive statistics

Standard deviation	352.5969019
Coefficient of variation (CV)	-166.919099
Kurtosis	45744.33541
Mean	-2.11238201
Median Absolute Deviation (MAD)	0.05
Skewness	-165.8537632
Sum	-196164.243
Variance	124324.5752
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.05	6876	7.4%
0.06	6328	6.8%
0.04	6268	6.7%
0.07	5152	5.5%
0.03	5060	5.4%
0.08	3853	4.1%
0.02	3759	4.0%
0.01	2882	3.1%
0.09	2868	3.1%
0	2355	2.5%
Other values (2987)	47463	51.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-88875.14	1	< 0.1%
-24848.48	1	< 0.1%
-24627.806	1	< 0.1%
-14360.51	1	< 0.1%
-10261.36	1	< 0.1%
-8691.5	1	< 0.1%
-8415.58	1	< 0.1%
-7590.735	1	< 0.1%
-6825.143	1	< 0.1%
-5207.41	1	< 0.1%

Value	Count	Frequency (%)
39500	1	< 0.1%
11228.85	1	< 0.1%
7468.65	1	< 0.1%
2137.43	1	< 0.1%
2082.77	1	< 0.1%
861.54	1	< 0.1%
813.81	1	< 0.1%
504.46	1	< 0.1%
483.459	1	< 0.1%
445.1	1	< 0.1%

Market Book Ratio
Real number (ℝ)

Distinct	49812
Distinct (%)	53.7%
Missing	57
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	358.5062651

Minimum	-3151500
Maximum	3455419.33
Zeros	50
Zeros (%)	0.1%
Negative	8923
Negative (%)	9.6%
Memory size	725.7 KiB

Quantile statistics

Minimum	-3151500
5-th percentile	-92.4185
Q1	11.2
median	58.28
Q3	240.14
95-th percentile	2170.874
Maximum	3455419.33
Range	6606919.33
Interquartile range (IQR)	228.94

Descriptive statistics

Standard deviation	26063.63798
Coefficient of variation (CV)	72.70064854
Kurtosis	8386.750539
Mean	358.5062651
Median Absolute Deviation (MAD)	56.36
Skewness	11.32109506
Sum	33274759
Variance	679313224.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	50	0.1%
1.72	26	< 0.1%
1.81	25	< 0.1%
1.65	25	< 0.1%
2.34	24	< 0.1%
1.58	24	< 0.1%
1.44	23	< 0.1%
2.45	23	< 0.1%
4.56	23	< 0.1%
1.6	22	< 0.1%
Other values (49802)	92550	99.7%
(Missing)	57	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-3151500	1	< 0.1%
-2306965.03	1	< 0.1%
-1696159	1	< 0.1%
-1136503.5	1	< 0.1%
-1076149.76	1	< 0.1%
-962043.59	1	< 0.1%
-843750	1	< 0.1%
-810300	1	< 0.1%
-804683.33	1	< 0.1%
-762128.84	1	< 0.1%

Value	Count	Frequency (%)
3455419.33	1	< 0.1%
2545400	1	< 0.1%
2291347.5	1	< 0.1%
1039500	1	< 0.1%
1020718.45	1	< 0.1%
1003884.81	1	< 0.1%
857782.98	1	< 0.1%
818383.5	1	< 0.1%
785496	1	< 0.1%
605045	1	< 0.1%

Assets Growth
Real number (ℝ)

HIGH CORRELATION
MISSING
SKEWED

Distinct	4650
Distinct (%)	5.4%
Missing	6701
Missing (%)	7.2%
Infinite	0
Infinite (%)	0.0%
Mean	1.294076824

Minimum	-1
Maximum	14231
Zeros	438
Zeros (%)	0.5%
Negative	30845
Negative (%)	33.2%
Memory size	725.7 KiB

Quantile statistics

Minimum	-1
5-th percentile	-0.388
Q1	-0.053
median	0.052
Q3	0.192
95-th percentile	1.037
Maximum	14231
Range	14232
Interquartile range (IQR)	0.245

Descriptive statistics

Standard deviation	73.76952173
Coefficient of variation (CV)	57.00551958
Kurtosis	22286.38885
Mean	1.294076824
Median Absolute Deviation (MAD)	0.119
Skewness	137.2063306
Sum	111511.894
Variance	5441.942336
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	438	0.5%
0.006	255	0.3%
0.023	254	0.3%
0.039	253	0.3%
0.033	251	0.3%
0.013	248	0.3%
0.071	248	0.3%
0.045	247	0.3%
0.036	246	0.3%
0.052	246	0.3%
Other values (4640)	83485	89.9%
(Missing)	6701	7.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	114	0.1%
-0.999	8	< 0.1%
-0.998	4	< 0.1%
-0.997	8	< 0.1%
-0.996	8	< 0.1%
-0.995	5	< 0.1%
-0.994	6	< 0.1%
-0.993	9	< 0.1%
-0.992	5	< 0.1%
-0.991	3	< 0.1%

Value	Count	Frequency (%)
14231	1	< 0.1%
10173.72	1	< 0.1%
7872	1	< 0.1%
5076	1	< 0.1%
4712	1	< 0.1%
2440.778	1	< 0.1%
2405	1	< 0.1%
2182.455	1	< 0.1%
2138.25	1	< 0.1%
1935.8	1	< 0.1%

Sales Growth
Real number (ℝ)

MISSING
SKEWED
ZEROS

Distinct	4619
Distinct (%)	5.4%
Missing	6701
Missing (%)	7.2%
Infinite	0
Infinite (%)	0.0%
Mean	1.900109329

Minimum	-27.431
Maximum	39850
Zeros	5018
Zeros (%)	5.4%
Negative	26340
Negative (%)	28.4%
Memory size	725.7 KiB

Quantile statistics

Minimum	-27.431
5-th percentile	-0.419
Q1	-0.034
median	0.06
Q3	0.204
95-th percentile	0.967
Maximum	39850
Range	39877.431
Interquartile range (IQR)	0.238

Descriptive statistics

Standard deviation	177.632638
Coefficient of variation (CV)	93.4854828
Kurtosis	39255.81681
Mean	1.900109329
Median Absolute Deviation (MAD)	0.116
Skewness	191.0078837
Sum	163734.321
Variance	31553.35409
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5018	5.4%
-1	699	0.8%
0.05	234	0.3%
0.033	224	0.2%
0.032	223	0.2%
0.08	222	0.2%
0.068	221	0.2%
0.076	220	0.2%
0.045	220	0.2%
0.034	219	0.2%
Other values (4609)	78671	84.7%
(Missing)	6701	7.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-27.431	1	< 0.1%
-9.286	1	< 0.1%
-6.488	1	< 0.1%
-3.798	1	< 0.1%
-3.562	1	< 0.1%
-3.124	1	< 0.1%
-1.923	1	< 0.1%
-1.899	1	< 0.1%
-1.783	1	< 0.1%
-1.633	1	< 0.1%

Value	Count	Frequency (%)
39850	1	< 0.1%
30245	1	< 0.1%
9326.5	1	< 0.1%
5887.231	1	< 0.1%
5203	1	< 0.1%
3701.467	1	< 0.1%
3213	1	< 0.1%
2996.667	1	< 0.1%
2250.842	1	< 0.1%
2167	1	< 0.1%

Employee Growth
Real number (ℝ)

HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	3308
Distinct (%)	3.9%
Missing	7010
Missing (%)	7.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.3433204444

Minimum	-1
Maximum	2699
Zeros	7394
Zeros (%)	8.0%
Negative	31627
Negative (%)	34.1%
Memory size	725.7 KiB

Quantile statistics

Minimum	-1
5-th percentile	-0.333
Q1	-0.048
median	0.017
Q3	0.131
95-th percentile	0.667
Maximum	2699
Range	2700
Interquartile range (IQR)	0.179

Descriptive statistics

Standard deviation	14.07415617
Coefficient of variation (CV)	40.99422683
Kurtosis	20454.00961
Mean	0.3433204444
Median Absolute Deviation (MAD)	0.087
Skewness	128.4063963
Sum	29478.18
Variance	198.081872
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7394	8.0%
0.2	328	0.4%
0.25	314	0.3%
0.333	314	0.3%
0.024	306	0.3%
0.071	305	0.3%
0.038	305	0.3%
0.1	303	0.3%
0.029	297	0.3%
0.045	295	0.3%
Other values (3298)	75701	81.5%
(Missing)	7010	7.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	228	0.2%
-0.999	3	< 0.1%
-0.998	1	< 0.1%
-0.997	5	< 0.1%
-0.996	1	< 0.1%
-0.994	4	< 0.1%
-0.993	4	< 0.1%
-0.992	6	< 0.1%
-0.991	8	< 0.1%
-0.99	3	< 0.1%

Value	Count	Frequency (%)
2699	1	< 0.1%
1671.5	1	< 0.1%
1600	1	< 0.1%
856.5	1	< 0.1%
818.277	1	< 0.1%
629	1	< 0.1%
569	1	< 0.1%
549.333	1	< 0.1%
449	1	< 0.1%
414.667	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	EPS	Liquidity	Profitability	Productivity	Leverage Ratio	Asset Turnover	Operational Margin	Return on Equity	Market Book Ratio	Assets Growth	Sales Growth	Employee Growth
0	1.58	0.36	0.18	0.13	1.33	1.77	0.07	0.15	2.22	NaN	NaN	NaN
1	1.41	0.36	0.19	0.12	1.31	1.59	0.07	0.13	2.41	0.126	0.014	0.040
2	0.31	0.32	0.13	0.08	1.03	1.55	0.05	0.04	2.56	0.368	0.328	0.567
3	0.71	0.28	0.14	0.08	0.80	1.39	0.06	0.05	5.28	-0.021	-0.119	-0.096
4	0.75	0.41	0.13	0.08	0.20	1.30	0.06	0.04	8.68	0.233	0.147	0.053
5	1.50	0.37	0.16	0.11	0.34	1.41	0.08	0.08	7.82	0.132	0.232	0.077
6	1.26	0.36	0.16	0.11	0.60	1.25	0.09	0.05	20.51	0.276	0.133	0.189
7	1.46	0.37	0.18	0.12	0.36	1.27	0.10	0.05	25.10	0.186	0.202	0.017
8	1.34	0.37	0.21	0.12	0.48	1.22	0.10	0.05	42.05	0.212	0.166	0.099
9	1.55	0.36	0.22	0.13	0.56	1.14	0.11	0.05	46.68	0.251	0.169	0.276

Last rows

	BK	EPS	Liquidity	Profitability	Productivity	Leverage Ratio	Asset Turnover	Operational Margin	Return on Equity	Market Book Ratio	Assets Growth	Sales Growth	Employee Growth
92862	0	-0.024	0.317	-0.329	-0.097	0.043	0.092	-1.057	-0.031	159.570	NaN	NaN	NaN
92863	0	-0.032	0.018	-0.090	-0.008	2.627	0.064	-0.126	-0.011	481.755	4.243	2.644	2.667
92864	0	-0.903	-0.038	-1.158	-0.916	-3.936	0.149	-6.147	-0.387	-539.641	-0.131	1.035	0.000
92865	0	-0.358	-0.065	-0.140	-0.013	1.549	0.137	-0.092	-0.176	-311.775	11.124	10.126	4.455
92866	0	-1.469	-0.013	-0.565	-0.246	5.769	0.365	-0.674	-8.159	-8.924	-0.348	0.738	-0.133
92867	0	-1.488	-0.015	-0.759	-0.057	-1042.105	0.174	-0.327	-6.614	-1.847	-0.073	-0.557	-0.077
92868	0	-1.808	0.094	-1.205	-0.121	-4.530	0.216	-0.561	-4.519	-2.475	-0.202	-0.011	-0.208
92869	0	-0.016	0.039	0.000	-0.082	0.745	0.254	-0.324	-0.569	3274.506	-0.168	-0.020	-0.105
92870	0	-0.133	0.054	-0.029	0.001	0.575	0.196	0.005	-0.086	36.475	0.077	-0.171	-0.059
92871	1	-0.648	-0.037	-0.220	-0.145	0.693	0.222	-0.651	-0.498	55.624	-0.064	0.065	0.063

Most frequently occurring

	EPS	Liquidity	Profitability	Productivity	Leverage Ratio	Asset Turnover	Operational Margin	Return on Equity	Market Book Ratio	Assets Growth	Sales Growth	Employee Growth	# duplicates
0	0.95	-0.05	0.07	0.06	2.07	0.42	0.13	0.06	29.37	0.541	0.336	-0.002	2
1	0.99	-0.05	0.07	0.09	1.33	0.70	0.13	0.05	43.74	-0.010	0.640	-0.078	2
2	1.57	0.01	0.11	0.08	1.11	0.29	0.26	0.08	187.14	-0.009	-0.001	-0.031	2
3	2.14	0.05	0.24	0.09	0.73	0.58	0.16	0.09	33.26	-0.002	0.005	0.020	2
4	2.15	0.05	0.23	0.09	0.69	0.58	0.16	0.09	33.35	0.036	-0.031	0.002	2
5	2.27	0.06	0.23	0.12	0.65	0.61	0.20	0.11	31.20	0.019	-0.020	-0.002	2
6	2.28	0.00	0.12	0.10	1.04	0.33	0.29	0.08	265.59	0.032	0.072	-0.011	2
7	2.29	-0.02	0.11	0.08	1.06	0.29	0.29	0.08	257.60	0.154	-0.006	-0.023	2
8	2.37	0.06	0.24	0.09	0.82	0.58	0.16	0.08	40.08	0.064	0.059	0.034	2
9	2.43	0.05	0.24	0.09	0.75	0.55	0.17	0.08	43.69	0.067	0.018	0.027	2

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequently occurring